﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Oracle.DataAccess.Client;

namespace WebApplication
{
    public partial class Activation : System.Web.UI.Page
    {
        OracleConnection conn;

        protected void Page_Load(object sender, EventArgs e)
        {
            conn = new OracleConnection();
            conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["OracleConnectionString"].ToString();

            string rfidquerystring = Request.QueryString["rfid"].ToString();

            try
            {
                String sql = "UPDATE klant_betalend SET geactiveerd='YES' WHERE rfid=" + rfidquerystring;
                conn.Open();
                OracleCommand cmd = new OracleCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
            }
            catch
            { }
        }
    }
}